<%@ page contentType="text/html; charset=utf-8" language="java" import="java.sql.*" errorPage="" %>
<%@ page import="com.util.*"%>

<%
DBO db=new DBO();
request.setCharacterEncoding("utf-8");
ResultSet rs=null;
String sql="";
int row=1;
        String id=(String)request.getParameter("id");//id
        String applyusername=(String)request.getParameter("applyusername");//申请人
        String applydate=(String)request.getParameter("applydate");//申请时间
        String mobile=(String)request.getParameter("mobile");//联系电话
        String title=(String)request.getParameter("title");//活动名称
        String usercount=(String)request.getParameter("usercount");//用户数量
        String bj=(String)request.getParameter("bj");//班级
        String actitvtyroom=(String)request.getParameter("actitvtyroom");//活动室
        String appointmentdate=(String)request.getParameter("appointmentdate");//预约时间
        String remark=(String)request.getParameter("remark");//备注
        String status=(String)request.getParameter("status");//状态
        String auditor=(String)request.getParameter("auditor");//审核人
/*
修改后台页面


*/	
 
sql="update actitvtyappointment set  applyusername='"+applyusername+"', applydate='"+applydate+"',  mobile='"+mobile+"',title='"+title+"',usercount='"+usercount+"',bj='"+bj+"',actitvtyroom='"+actitvtyroom+"',appointmentdate='"+appointmentdate+"',remark='"+remark+"',status='"+status+"',auditor='"+auditor+" 'where id='"+id+"'";

 //int row=0;

try{

        System.out.println(sql);
        row=db.update(sql);
}catch(Exception e){
        System.out.println(e.toString());}
        if(row==1){
                out.println("<script>");
                out.println("alert('操作成功');");
                out.println("window.location='list.jsp'");
                out.println("</script>");
        }else{
                out.println("<script>");
                out.println("alert('操作失败');");
                out.println("window.location='list.jsp'");
                out.println("</script>");
        }
        db.close();
%>

